Pivotal Greenplum data types
The Pivotal Greenplum database for Qlik Replicate supports most Pivotal Greenplum data types. The following table shows the Pivotal Greenplum target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using. For additional information about Qlik Replicate data types, see Replicate data types.
| Qlik Replicate Data Types | Pivotal Greenplum Data Types |
|---|---|
|
BOOLEAN |
bool |
|
BYTES |
bytea |
|
DATE |
date |
|
TIME |
time (p) |
|
DATETIME |
timestamp (p) |
|
INT1 |
int2 |
|
INT2 |
int2 |
|
INT4 |
int4 |
|
INT8 |
int8 |
|
NUMERIC |
numeric (p,s) |
|
REAL4 |
float4 |
|
REAL8 |
float8 |
|
STRING |
varchar (n); n=data length |
|
UINT1 |
int2 |
|
UINT2 |
int4 |
|
UINT4 |
int8 |
|
UINT8 |
numeric (20) |
|
WSTRING |
varchar (n); n=length |
|
BLOB |
bytea To use this data type with Qlik Replicate, you must enable the use of BLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. The Pivotal Greenplum target database has limited LOB support. You cannot use an unlimited LOB size for this database. For more information, see Task Settings/Metadata. |
|
CLOB |
text To use this data type with Qlik Replicate, you must enable the use of CLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. The Pivotal Greenplum target database has limited LOB support. You cannot use an unlimited LOB size for this database. For more information, see Task Settings/Metadata. |
|
NCLOB |
text To use this data type with Qlik Replicate, you must enable the use of NCLOBs for a specific task. During CDC or during Full Load when the Allow unlimited LOB size option is enabled, LOB data types are supported only in tables with a primary key or unique index. The Pivotal Greenplum target database has limited LOB support. You cannot use an unlimited LOB size for this database. For more information, see Task Settings/Metadata. |